﻿namespace EaseDapper.Constants
{
    public class Templates
    {
        #region Query Template
        internal const string SqlHeadString = "SELECT * FROM `{0}`";
        internal const string SqlBetweenString = "{0} BETWEEN {1} AND {2}";
        internal const string SqlLimitString = " LIMIT {0}";
        internal const string SqlExistString = "{0} ( {1} )";
        internal const string SqlGroupByString = " Group BY {0}";
        internal const string SqlHavingString = " Having {0}";
        internal const string SqlOrderByString = " ORDER BY {0} {1}";
        #endregion

        #region Delete Template
        internal const string DeleteString = "DELETE FROM {0}";
        #endregion

        #region Update Template
        internal const string UpdateString = "Update {0} SET ";
        internal const string EqualString = " {0} = {1}";
        #endregion
    }
}
